IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spProductSelectByCategory')
	BEGIN
		DROP  PROCEDURE  spProductSelectByCategory
	END
GO
-- =============================================
-- Author:		<NamTP>
-- Create date: <Apr 27, 2012>
-- Description:	<Get name industry from phrases table>
-- TEST: EXEC spProductSelectByCategory 465
-- =============================================
CREATE PROCEDURE spProductSelectByCategory
	@CategoryId INT
AS
BEGIN
	
	SELECT [ProductID]
      ,[ProductName]
      ,[SupplierID]
      ,[CategoryID]
      ,[QuantityPerUnit]
      ,[UnitPrice]
      ,[UnitsInStock]
      ,[UnitsOnOrder]
      ,[ReorderLevel]
      ,[Discontinued]
	FROM [Products]
	WHERE [CategoryID] = @CategoryId
END
GO
